USE [IntTester]
GO

/****** Object:  StoredProcedure [dbo].[pr_GetTestRunDetailsPerNameAndStatus]    Script Date: 03/10/2014 16:39:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pr_GetTestRunDetailsPerNameAndStatus]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pr_GetTestRunDetailsPerNameAndStatus]
GO

USE [IntTester]
GO

/****** Object:  StoredProcedure [dbo].[pr_GetTestRunDetailsPerNameAndStatus]    Script Date: 03/10/2014 16:39:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[pr_GetTestRunDetailsPerNameAndStatus]
	-- Add the parameters for the stored procedure here
	@testName nvarchar(500),
	@runStatus nvarchar(500)
AS
BEGIN
	
	SELECT     *
		FROM         dbo.TestRun
		
		where TestName=@testName and RunStatus=@runStatus
	
END

GO


